In [184]:
import boto3
import networkx as nx
import time
from py2neo import Graph, Node, Relationship
import community

Lets download the data first.


In [135]:
session = boto3.Session(
    aws_access_key_id='AKIAJA5TRUVIP2L4FSOA',
    aws_secret_access_key='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',
    region_name='eu-central-1'
)
s3_client_epfl = session.client("s3")

In [136]:
bucket = 'somed.networks'
key = 'test.gexf'

with open('data.nx', 'wb') as data_file:
        s3_client_epfl.download_fileobj(bucket, key, data_file)

Lets read data


In [137]:
G = nx.read_gexf('data.nx')

Delete everything before add something


In [205]:
graph = Graph("http://neo4j:qqwweerr@localhost:7474/db/data/")

# graph.delete_all() # Be carefull

In [21]:
nodes = {}
edges = {}

root_partition = Node("Community", name=str(0), optainedBy="Root", timestamp=str(time.time()))
graph.create(root_partition)

for node in G.nodes():
    nodes[node] = Node("Instauser", name=str(node))
    graph.create(nodes[node])
    
for source, target in G.edges():
    edges[str(source) + str(target)] = Relationship(nodes[str(source)], "LIKES", nodes[str(target)])
    graph.create(edges[str(source) + str(target)])
    

for _, node in nodes.items():
    root_community_edge = Relationship(node, "MEMBER_OF", root_partition)
    graph.create(root_community_edge)

Create Order Node


In [31]:
query = """ 
MATCH (a:Order) RETURN MAX(a.name) AS m
    """

max_result = graph.run(query).data()[0]
max_order = int(float(max_result['m'])) + 1 if max_result['m'] else 0

order_node = Node("Order", name=str(max_order), optainedBy="Louvain", timestamp=str(time.time()))
graph.create(order_node)

In [59]:



Out[59]:
1

In [60]:
query = """
        MATCH (a:Community),(b:Order)
        WHERE a.name = '{}' AND b.name = '{}'
        CREATE (a)-[r:SUB_COMMUNITY_OF]->(b)
        RETURN r
    """.format("0", "0")
graph.run(query).data()


Out[60]:
[{'r': (0)-[:SUB_COMMUNITY_OF {}]->(0)}]

Create community nodes


In [33]:
partitions = community.best_partition(G)

In [46]:
query = """ 
MATCH (a:Community) RETURN MAX(a.name) AS m
    """

max_result = graph.run(query).data()[0]
max_community = int(float(max_result['m'])) + 1 if max_result['m'] else 0

partitions_ids_map = {x: x + max_community for x in list(set(partitions.values()))}
for instauser in list(partitions.keys()):
    partitions[instauser] = partitions_ids_map[partitions[instauser]]

partitions


Out[46]:
{'3934946894': 1,
 '4230604813': 2,
 '174644238': 3,
 '964190736': 1,
 '26613266': 3,
 '1165208595': 3,
 '5698811419': 1,
 '5897207838': 1,
 '5869957667': 4,
 '3244036142': 5,
 '3993411126': 1,
 '200215607': 6,
 '2160086594': 3,
 '179748419': 1,
 '5551530569': 1,
 '5971046986': 3,
 '174089804': 1,
 '19520601': 1,
 '195734630': 1,
 '3666044013': 2,
 '3155481714': 6,
 '269351546': 1,
 '240518274': 3,
 '4791608452': 7,
 '4041773700': 1,
 '5695384717': 1,
 '6003347087': 2,
 '1942468756': 8,
 '4111757972': 1,
 '365822104': 9,
 '5207543968': 1,
 '1605548706': 1,
 '225870512': 1,
 '1598824113': 1,
 '9800370': 1,
 '5823585976': 3,
 '1962759868': 1,
 '3150935741': 1,
 '5912606913': 3,
 '222219972': 1,
 '5844123847': 1,
 '33864905': 1,
 '4140014299': 1,
 '4175255771': 10,
 '4175570144': 3,
 '2895420648': 3,
 '5981342956': 3,
 '4197170416': 1,
 '2179036407': 3,
 '5503459066': 1,
 '5521227517': 1,
 '1550128894': 1,
 '5959393044': 1,
 '235886891': 3,
 '3098844472': 1,
 '6345238331': 11,
 '3565345596': 1,
 '183715133': 1,
 '3316168524': 3,
 '2297825111': 1,
 '3270229338': 3,
 '1466519394': 3,
 '2888550': 3,
 '184039281': 1,
 '1785609586': 3,
 '418103158': 1,
 '48353153': 1,
 '567986052': 1,
 '4697723782': 6,
 '2000332172': 3,
 '2519484817': 10,
 '3233675160': 3,
 '287450010': 1,
 '4178945948': 3,
 '3494104989': 3,
 '4087396254': 1,
 '15612836': 3,
 '5820610994': 12,
 '2219916744': 1,
 '8126408': 3,
 '1477140432': 12,
 '28027885': 5,
 '495726579': 1,
 '2010378230': 1,
 '2031084023': 3,
 '3169050616': 3,
 '514563397': 2,
 '180232412': 3,
 '179046170': 1,
 '4176061394': 3,
 '1148688035': 11,
 '2290489168': 3,
 '2106215713': 13,
 '576646295': 10,
 '21701557': 3,
 '4267063598': 3,
 '216802064': 14,
 '248966742': 3,
 '179674828': 3,
 '1082579': 3,
 '4549962994': 3,
 '2935842710': 1,
 '1621229824': 15,
 '1438900879': 1,
 '21944101': 9,
 '1434581753': 1,
 '1372615': 5,
 '3467174123': 3,
 '299853862': 10,
 '215389991': 3,
 '1901852384': 3,
 '6681069935': 3,
 '4357981756': 3,
 '1714348141': 3,
 '204604353': 16,
 '30267593': 3,
 '1435956629': 15,
 '6001117': 10,
 '2223081174': 3,
 '4251137497': 3,
 '1903116195': 3,
 '874294559': 1,
 '6215158476': 3,
 '2168659671': 3,
 '2358075593': 3,
 '385517618': 3,
 '23892074': 14,
 '3064760620': 1,
 '6274548619': 15,
 '2020475721': 5,
 '5835326148': 3,
 '2955155': 3,
 '248158977': 17,
 '26696131': 3,
 '146188250': 3,
 '6344328800': 3,
 '1088853708': 7,
 '4783160536': 3,
 '593438352': 3,
 '287941292': 3,
 '188928796': 17,
 '24102401': 3,
 '232681400': 3,
 '223417243': 18,
 '267471622': 16,
 '30300717': 3,
 '241055075': 15,
 '484662508': 19,
 '5687089009': 3,
 '26095874': 19,
 '3537607644': 19,
 '520313851': 3,
 '22306594': 20,
 '516211278': 20,
 '254195225': 15,
 '4317836140': 3,
 '1592126461': 3,
 '6653641291': 11,
 '3242840377': 3,
 '279861922': 3,
 '12153894': 20,
 '1497105595': 3,
 '312424350': 20,
 '645395727': 3,
 '501041083': 1,
 '1058110112': 5,
 '1352253289': 21,
 '667419698': 3,
 '5998078112': 15,
 '833212899': 20,
 '15888820': 8,
 '21137778': 3,
 '36040760': 3,
 '544414267': 3,
 '4078330356': 1,
 '260682849': 20,
 '616139812': 3,
 '5689260657': 2,
 '293117712': 3,
 '6109762900': 18,
 '226670567': 3,
 '572331627': 11,
 '8022712': 20,
 '27130999': 7,
 '10763916': 15,
 '5452219719': 3,
 '20128743': 2,
 '1803697881': 3,
 '443412570': 3,
 '325542322': 7,
 '3077709591': 3,
 '247403319': 19,
 '3922594085': 1,
 '6064518039': 1,
 '5894405550': 3,
 '1473554270': 1,
 '586429775': 3,
 '8706123': 1,
 '45905334': 1,
 '392646900': 20,
 '29726463': 1,
 '7000215': 20,
 '1549176469': 3,
 '509243045': 3,
 '994569431': 3,
 '2884111258': 3,
 '4126703041': 3,
 '605356465': 18,
 '3238452178': 3,
 '6293052862': 3,
 '1822640728': 3,
 '300081496': 2,
 '4022386921': 3,
 '5878368681': 3,
 '3339593': 15,
 '1264193341': 6,
 '3159457274': 3,
 '3030964677': 3,
 '1413574577': 3,
 '413966600': 3,
 '52460547': 16,
 '3797062046': 20,
 '230679481': 3,
 '8332795': 3,
 '208343105': 1,
 '3273018912': 13,
 '6229116804': 8,
 '3494314620': 15,
 '36373540': 11,
 '1213863357': 1,
 '321948069': 3,
 '267265644': 3,
 '12910798': 3,
 '273432248': 18,
 '1017349': 3,
 '2382069': 1,
 '4980365318': 3,
 '1284926018': 3,
 '4371011275': 15,
 '478707726': 15,
 '1145612351': 15,
 '1067474596': 3,
 '385755853': 22,
 '3271016848': 20,
 '1765336794': 3,
 '50675368': 3,
 '3041668335': 1,
 '1774840149': 1,
 '260538037': 3,
 '256751191': 3,
 '4973949': 6,
 '5373259200': 3,
 '186382614': 15,
 '1639936926': 8,
 '361614659': 1,
 '3697427': 3,
 '269402371': 23,
 '5702835311': 3,
 '202775785': 3,
 '245651928': 3,
 '19521217': 20,
 '21294919': 3,
 '1978264264': 3,
 '1434753325': 1,
 '1389066358': 3,
 '7427792': 3,
 '242500155': 3,
 '1454104140': 15,
 '1918118502': 3,
 '3075973833': 3,
 '4121459758': 3,
 '6284151483': 20,
 '1671937718': 3,
 '32654633': 20,
 '203433907': 3,
 '4176873099': 3,
 '53126551': 22,
 '4211836699': 20,
 '232474910': 2,
 '20046354': 1,
 '3165216239': 1,
 '3786700052': 1,
 '190276210': 3,
 '10827472': 3,
 '1547524380': 3,
 '18321726': 1,
 '30543995': 3,
 '563890495': 1,
 '4646383480': 8,
 '308801506': 3,
 '184106429': 5,
 '3970819079': 3,
 '2197833744': 3,
 '2374630650': 11,
 '4651626725': 20,
 '3302662': 6,
 '247643050': 6,
 '10006516': 3,
 '620245485': 3,
 '2256616452': 18,
 '191253546': 15,
 '5709269759': 3,
 '1657974345': 3,
 '5481428825': 1,
 '569944258': 20,
 '1412836231': 1,
 '280742189': 2,
 '27528432': 16,
 '1538524058': 16,
 '1362222525': 1,
 '1668430946': 1,
 '4708714124': 20,
 '50654006': 3,
 '3817329867': 3,
 '27476126': 6,
 '1402995804': 1,
 '3965609558': 4,
 '49005740': 1,
 '191831882': 5,
 '34688026': 5,
 '182957431': 6,
 '1671345795': 24,
 '2032443413': 3,
 '6019584159': 3,
 '27051867': 3,
 '1687529339': 1,
 '6156498867': 3,
 '3418475102': 13,
 '18115599': 10,
 '9077564': 1,
 '186847283': 5,
 '16618340': 6,
 '249001192': 14,
 '2285050274': 1,
 '5345387909': 20,
 '1098219395': 3,
 '563174364': 1,
 '4943126319': 3,
 '5324633532': 3,
 '2923563245': 11,
 '5377383050': 3,
 '21073842': 1,
 '2021477055': 1,
 '217984476': 21,
 '217987366': 21,
 '335399208': 15,
 '5656922417': 9,
 '249081804': 6,
 '10600702': 15,
 '316342407': 3,
 '393196661': 3,
 '4701216618': 3,
 '4282303298': 3,
 '25844058': 1,
 '1624284281': 15,
 '2182421035': 3,
 '931446656': 1,
 '2978827196': 7,
 '5754827059': 17,
 '2166421': 20,
 '645580537': 3,
 '1438356529': 5,
 '180046608': 16,
 '4024050782': 20,
 '1947621764': 5,
 '5309904310': 1,
 '1478737468': 3,
 '424752035': 11,
 '3273649203': 3,
 '394905277': 25,
 '1388280780': 2,
 '1533010882': 1,
 '187287702': 7,
 '4119866622': 7,
 '299162365': 3,
 '1367210665': 20,
 '1269666801': 19,
 '228629230': 15,
 '5356803631': 15,
 '277231157': 3,
 '41358964': 2,
 '46613747': 20,
 '208237879': 19,
 '4747605': 20,
 '181780912': 9,
 '6175005041': 5,
 '327500626': 1,
 '314005930': 5,
 '1688876491': 2,
 '1193164151': 20,
 '6502761420': 7,
 '3681723336': 4,
 '5573008866': 12,
 '664272893': 6,
 '751829132': 8,
 '8627519': 15,
 '2053866313': 15,
 '798582599': 8,
 '2304724460': 1,
 '6424210419': 2,
 '1513245804': 1,
 '356405755': 15,
 '369174070': 2,
 '256001852': 20,
 '205807404': 3,
 '326817529': 5,
 '301152290': 9,
 '46817235': 1,
 '2323869216': 19,
 '292146084': 15,
 '1808503': 3,
 '261819113': 3,
 '247096908': 3,
 '1592830482': 5,
 '236752227': 6,
 '1267130201': 3,
 '2372185170': 10,
 '28550688': 3,
 '2941956041': 1,
 '3069735413': 5,
 '4667506415': 3,
 '5998122026': 5,
 '190503793': 2,
 '2457389294': 10,
 '1996724786': 3,
 '2306026954': 5,
 '348390354': 11,
 '218762100': 11,
 '260514674': 3,
 '697070003': 8,
 '4865182701': 7,
 '288287844': 2,
 '1446248071': 8,
 '3826251040': 3,
 '4787003648': 1,
 '231291097': 9,
 '28074241': 24,
 '21478963': 15,
 '6191415789': 17,
 '5835654040': 1,
 '3639963873': 3,
 '368338309': 22,
 '273025204': 2,
 '210752730': 11,
 '719126554': 11,
 '5609133211': 3,
 '988614239': 11,
 '203250357': 15,
 '235512345': 15,
 '1711634371': 3,
 '4076427613': 3,
 '44697202': 3,
 '261430853': 3,
 '4215670355': 1,
 '49896139': 10,
 '3180498348': 5,
 '22969622': 1,
 '2991450862': 1,
 '2073914956': 3,
 '4282639845': 3,
 '4038125334': 7,
 '1336916340': 6,
 '36192544': 9,
 '215135938': 3,
 '185676986': 1,
 '1459466500': 15,
 '3880303970': 3,
 '2315935497': 15,
 '2018199124': 15,
 '144072519': 15,
 '1646944783': 15,
 '30647833': 15,
 '30787579': 20,
 '6208202863': 3,
 '425958346': 9,
 '1286445729': 9,
 '5533635224': 9,
 '338481447': 15,
 '260394556': 15,
 '1399484649': 5,
 '174350068': 26,
 '3841408634': 5,
 '1263840307': 3,
 '3290419312': 3,
 '3681792014': 3,
 '919110649': 20,
 '3946025902': 3,
 '509837977': 1,
 '221153814': 16,
 '6123992717': 3,
 '6026460602': 5,
 '254103456': 5,
 '1800287360': 5,
 '13135911': 3,
 '1122941910': 3,
 '347685013': 3,
 '3180220253': 20,
 '2172390338': 3,
 '1524392236': 2,
 '10847580': 5,
 '6430151015': 5,
 '1472885285': 9,
 '1808976609': 5,
 '4274655426': 3,
 '2015104312': 11,
 '369540386': 3,
 '54129645': 16,
 '4850389360': 20,
 '5769846097': 1,
 '2139870205': 24,
 '5323136': 20,
 '338260218': 3,
 '48719931': 16,
 '252044589': 9,
 '1563574838': 3,
 '738283562': 21,
 '4318404533': 17,
 '2133918012': 3,
 '28303342': 15,
 '206048629': 3,
 '51529689': 17,
 '26909445': 6,
 '20291444': 20,
 '2110776': 17,
 '1647728745': 1,
 '3562599484': 15,
 '42017363': 1,
 '10716139': 21,
 '198838006': 6,
 '281586948': 1,
 '27927875': 1,
 '5486274464': 1,
 '16071072': 13,
 '2118522204': 20,
 '1832130224': 17,
 '2110046240': 1,
 '5651087079': 22,
 '181320576': 15,
 '372826044': 3,
 '55336649': 9,
 '4092799256': 3,
 '16371891': 10,
 '2415121007': 7,
 '5706854620': 3,
 '1548037533': 20,
 '1040579163': 21,
 '4078049902': 5,
 '8398964': 3,
 '525154164': 3,
 '1602102237': 13,
 '834416160': 3,
 '609791278': 3,
 '908928723': 16,
 '236677439': 5,
 '18489940': 5,
 '787440': 1,
 '1800389606': 10,
 '281577676': 6,
 '275955651': 9,
 '3874605713': 3,
 '235323470': 10,
 '4297944376': 10,
 '726404': 1,
 '1537486573': 10,
 '4406801': 26,
 '2405038247': 5,
 '53672579': 7,
 '1549748689': 5,
 '2800214831': 9,
 '8612307': 3,
 '319273303': 5,
 '1791353719': 16,
 '2199341996': 12,
 '280625470': 11,
 '4141881': 15,
 '8140390': 5,
 '145520603': 20,
 '2369018813': 23,
 '4524111178': 5,
 '368554936': 5,
 '2225983430': 11,
 '550582470': 11,
 '5038472867': 15,
 '192193355': 9,
 '546313503': 3,
 '4116478016': 3,
 '308627208': 3,
 '2379866657': 3,
 '2759691616': 3,
 '184341232': 15,
 '737424602': 15,
 '4244089317': 5,
 '899621': 8,
 '173716360': 2,
 '321714391': 19,
 '1415029645': 19,
 '4637632': 3,
 '206112': 3,
 '259343744': 9,
 '213135420': 10,
 '1989403630': 13,
 '209440386': 12,
 '29124911': 12,
 '311460561': 6,
 '281680987': 9,
 '5332709178': 9,
 '2418384166': 19,
 '6641594661': 20,
 '5600972524': 3,
 '34282004': 21,
 '3804215976': 21,
 '410756378': 21,
 '3255499369': 15,
 '224992119': 3,
 '465130017': 9,
 '5443222529': 17,
 '190885660': 10,
 '2140638690': 1,
 '1480385540': 3,
 '5982693297': 20,
 '250924595': 15,
 '189645480': 13,
 '5690877169': 9,
 '5481826528': 21,
 '30158313': 22,
 '1016386667': 5,
 '4523934210': 1,
 '8651136': 10,
 '4731503914': 9,
 '683684066': 9,
 '243704056': 9,
 '642816441': 3,
 '180175491': 10,
 '353342370': 14,
 '897407171': 22,
 '184287253': 5,
 '1565958668': 3,
 '225351788': 10,
 '23448307': 9,
 '6523826266': 5,
 '522688754': 17,
 '3254857367': 3,
 '1413763786': 13,
 '206213364': 15,
 '1647620983': 10,
 '595075084': 10,
 '262865562': 10,
 '1413625806': 3,
 '4303289276': 11,
 '35445509': 10,
 '201183570': 16,
 '4775459479': 9,
 '284385394': 5,
 '1595558697': 15,
 '423487550': 4,
 '2241339600': 3,
 '1385137497': 2,
 '2292090531': 20,
 '304658119': 8,
 '1590242925': 3,
 '4412150793': 14,
 '3549111412': 17,
 '491182177': 3,
 '5775020584': 9,
 '9169305': 14,
 '639484132': 3,
 '1516803970': 20,
 '6314036670': 3,
 '1399009015': 3,
 '5876865778': 25,
 '356612143': 3,
 '5402506066': 3,
 '176802374': 3,
 '1545820344': 20,
 '25178863': 3,
 '1590441534': 20,
 '357214899': 3,
 '11614709': 10,
 '3556721352': 4,
 '37087529': 12,
 '2280875951': 3,
 '3258377950': 4,
 '3569114007': 2,
 '6575907551': 3,
 '5663780632': 20,
 '4885263619': 3,
 '6312484429': 19,
 '2226371710': 6,
 '20748613': 11,
 '342453462': 8,
 '4117060951': 20,
 '5983034505': 4,
 '1364035962': 17,
 '197656233': 3,
 '4635561283': 3,
 '332878781': 3,
 '1780087615': 3,
 '1321687411': 3,
 '1620994874': 3,
 '1819159587': 3,
 '1244907650': 3,
 '186453646': 11,
 '5121565584': 4,
 '1562849165': 21,
 '2116036696': 3,
 '174921635': 3,
 '1176657923': 3,
 '1394180401': 3,
 '240224942': 17,
 '532756154': 19,
 '2258287579': 11,
 '1172636595': 20,
 '187235625': 9,
 '968105924': 15,
 '281688181': 22,
 '54849423': 15,
 '194173007': 5,
 '3075383989': 14,
 '5635283125': 5,
 '9140256': 5,
 '3678834236': 9,
 '23780476': 5,
 '3111400846': 24,
 '445173203': 9,
 '222888683': 5,
 '1682587179': 5,
 '1038655044': 5,
 '4004493': 5,
 '6669112221': 5,
 '293812966': 13,
 '2080264835': 5,
 '34312408': 3,
 '15544884': 1,
 '4161379811': 15,
 '476602608': 15,
 '268994055': 9,
 '3306308329': 3,
 '245429022': 1,
 '5570819771': 18,
 '4048151096': 9,
 '3054910016': 1,
 '1104562426': 1,
 '13267212': 1,
 '6019446781': 15,
 '5671763690': 4,
 '1359739425': 6,
 '6056922568': 3,
 '1688088235': 14,
 '189344109': 1,
 '217315870': 3,
 '221747650': 20,
 '2271297765': 1,
 '665618707': 11,
 '1128642745': 15,
 '2066080425': 15,
 '46091385': 1,
 '4078694852': 3,
 '1338601945': 3,
 '6234704484': 9,
 '1691750097': 26,
 '242492259': 9,
 '423016902': 2,
 '198953576': 18,
 '5612398997': 15,
 '2017561952': 5,
 '209373583': 15,
 '639622821': 15,
 '485179292': 3,
 '1628447267': 20,
 '241652870': 11,
 '186137679': 5,
 '839399753': 19,
 '4215611586': 19,
 '6098994613': 19,
 '49469101': 12,
 '613268772': 5,
 '3440248314': 1,
 '210403810': 7,
 '354719407': 7,
 '1491273811': 2,
 '2099173097': 3,
 '187715799': 15,
 '339601': 11,
 '1819350163': 15,
 '1577310323': 8,
 '5853238148': 8,
 '1572308387': 3,
 '3086206762': 24,
 '5785724551': 24,
 '6636265838': 24,
 '39876160': 1,
 '3534188609': 6,
 '1935462489': 3,
 '476189281': 5,
 '4275301473': 15,
 '5866728559': 3,
 '508416624': 13,
 '4086087305': 3,
 '2460636811': 10,
 '2269099666': 2,
 '2463163041': 5,
 '187629218': 15,
 '13430434': 5,
 '6045727913': 5,
 '5596717742': 24,
 '4725080785': 24,
 '255907554': 5,
 '1506213605': 3,
 '3232753894': 3,
 '5357490920': 24,
 '1344734453': 15,
 '2258191611': 24,
 '4144609546': 15,
 '178999578': 15,
 '5721435943': 24,
 '40324904': 15,
 '1610345256': 9,
 '3674394957': 2,
 '23243096': 24,
 '41968988': 24,
 '5747402590': 3,
 '2294696801': 3,
 '291904355': 3,
 '144951142': 10,
 '3310958': 3,
 '3640174965': 11,
 '4264945035': 15,
 '198481320': 15,
 '1169454003': 3,
 '143847884': 5,
 '16618964': 3,
 '5728534999': 24,
 '4056288221': 5,
 '568992229': 3,
 '1992471526': 3,
 '1431656439': 15,
 '340223486': 1,
 '5790833518': 6,
 '742315155': 5,
 '194695770': 24,
 '253130753': 24,
 '413454351': 21,
 '5740686863': 20,
 '1961259560': 24,
 '4475998250': 24,
 '1211207724': 13,
 '192275013': 24,
 '1223018058': 5,
 '206622202': 24,
 '2251056211': 24,
 '552023127': 18,
 '22198385': 3,
 '4799603': 24,
 '3141249': 3,
 '176025225': 24,
 '3148773005': 24,
 '279474841': 24,
 '1743812268': 24,
 '4212508857': 3,
 '186680001': 24,
 '267951829': 3,
 '266415318': 5,
 '4583759576': 24,
 '5722923737': 20,
 '3000210668': 24,
 '1414153984': 24,
 '498031379': 8,
 '10896661': 5,
 '4233344332': 24,
 '276851036': 24,
 '32372064': 3,
 '183152016': 24,
 '22069152': 24,
 '32687542': 4,
 '34625474': 20,
 '3578871749': 3,
 '4158328774': 24,
 '1025978838': 24,
 '4626777063': 24,
 '244360169': 24,
 '3921438202': 1,
 '21902845': 24,
 '1548994050': 3,
 '3641395214': 1,
 '213018129': 15,
 '1963354644': 24,
 '550475287': 24,
 '2198366763': 24,
 '745667120': 20,
 '1695419955': 19,
 '6045137485': 3,
 '336346717': 24,
 '2091450473': 1,
 '6508661': 15,
 '329289335': 3,
 '2163345018': 3,
 '5554387584': 1,
 '1334772872': 15,
 '1595627660': 21,
 '3258906765': 1,
 '355482': 24,
 '872948891': 24,
 '1457598113': 24,
 '12447912': 5,
 '4285782721': 14,
 '5973713606': 1,
 '1583922888': 24,
 '6326256344': 1,
 '1441760480': 9,
 '1446976226': 3,
 '1763168996': 24,
 '1989401318': 24,
 '2159493350': 24,
 '425700585': 2,
 '2960009966': 1,
 '499688189': 11,
 '186165511': 9,
 '1635084040': 15,
 '204512011': 15,
 '3159685405': 15,
 '307350820': 3,
 '190918971': 21,
 '10868546': 8,
 '15796048': 15,
 '3444023646': 24,
 '1700271461': 24,
 '250400135': 9,
 '29808011': 24,
 '5667993492': 3,
 '1574088604': 15,
 '221624247': 24,
 '209174967': 24,
 '2162409408': 11,
 '365353935': 6,
 '630785491': 24,
 '9343451': 24,
 '1441714140': 2,
 '201620465': 23,
 '4116877811': 24,
 '5924696059': 24,
 '313723523': 2,
 '3476606464': 11,
 '4824472579': 24,
 '2039707661': 24,
 '1551965712': 6,
 '4631440970': 17,
 '2283259469': 15,
 '194841177': 3,
 '2271479412': 9,
 '555650': 15,
 '2275500165': 3,
 '2939144853': 1,
 '4524163738': 3,
 '245238480': 3,
 '1282856144': 1,
 '6253366489': 3,
 '1351881982': 6,
 '2296283402': 17,
 '1666413853': 2,
 '4206765358': 20,
 '5358289202': 16,
 '3947219768': 20,
 '46707517': 1,
 '1494892870': 16,
 '798072135': 3,
 '5635425623': 6,
 '558868830': 24,
 '4177249171': 3,
 '1088016286': 3,
 '3233172400': 20,
 '3040817088': 11,
 '5451343305': 3,
 '5510772685': 24,
 '3644576219': 15,
 '144582111': 20,
 '2129814509': 1,
 '4522829815': 3,
 '178315651': 24,
 '364209283': 24,
 '4064937488': 24,
 '3640879767': 3,
 '1551541792': 24,
 '2956569515': 24,
 '1212761258': 24,
 '252533585': 24,
 '5695808211': 18,
 '2218177882': 24,
 '3598887131': 24,
 '5870917239': 24,
 '200533117': 15,
 '5735846448': 1,
 '19643009': 6,
 '1990882094': 9,
 '1979727724': 6,
 '227120226': 13,
 '1970358451': 7,
 '355022486': 3,
 '2986675959': 21,
 '25273472': 24,
 '2011497647': 9,
 ...}

Okey we now have communities lets add them


In [55]:
community_nodes = {}
for partition in list(set(partitions_ids_map.values())):

    community_nodes[partition] = Node("Community", name=str(partition))
    graph.create(community_nodes[partition])

    sub_community_of = Relationship(community_nodes[partition], "SUB_COMMUNITY_OF", root_partition)
    graph.create(sub_community_of)
    
    order_of = Relationship(community_nodes[partition], "ORDER_OF", order_node)
    graph.create(order_of)

for instauser_id, partition in partitions.items():
    member_of = Relationship(nodes[instauser_id], "MEMBER_OF", community_nodes[partition])
    graph.create(member_of)

In [50]:
partitions_ids


Out[50]:
{0: 1,
 1: 2,
 2: 3,
 3: 4,
 4: 5,
 5: 6,
 6: 7,
 7: 8,
 8: 9,
 9: 10,
 10: 11,
 11: 12,
 12: 13,
 13: 14,
 14: 15,
 15: 16,
 16: 17,
 17: 18,
 18: 19,
 19: 20,
 20: 21,
 21: 22,
 22: 23,
 23: 24,
 24: 25,
 25: 26,
 26: 27,
 27: 28,
 28: 29,
 29: 30,
 30: 31,
 31: 32,
 32: 33}

In [203]:
query = \
    """ 
    MATCH () - [a:MEMBER_OF] - () DELETE a
"""
max_result = graph.run(query).data()

query = \
    """ 
    MATCH () - [a:ORDER_OF] - () DELETE a
"""
max_result = graph.run(query).data()

query = \
    """ 
    MATCH () - [a:SUB_COMMUNITY_OF] - () DELETE a
"""
max_result = graph.run(query).data()

query = \
    """ 
    MATCH () - [a:PROCESSED_BY] - () DELETE a
"""
max_result = graph.run(query).data()

query = \
    """ 
    MATCH () - [a:CREATE] - () DELETE a
"""
max_result = graph.run(query).data()


query = \
    """ 
    MATCH (a:Community) DELETE a
"""
max_result = graph.run(query).data()

query = \
    """ 
    MATCH (a:Order) DELETE a
"""
max_result = graph.run(query).data()

In [ ]:
root_node = Node("Community", name=str(0))
graph.create(root_node)

for instauser_id, partition in communities.items():
    query = """
        MATCH (a:Instauser),(b:Community)
        WHERE a.name = '{}' AND b.name = '{}'
        CREATE (a)-[r:MEMBER_OF]->(b)
        RETURN r
    """.format(instauser_id, '0')
    graph.run(query)

In [125]:
import community

partitions = community.best_partition(G)

parent_community_id = '0'
communities = partitions
algorithm = 'louvain'

database.insert_community_analysis(communities, parent_community_id, algorithm)


            MATCH (a:Community),(b:Order)
            WHERE a.name = '0' AND b.name = '2'
            CREATE (a)-[r:PROCESSED_BY]->(b)
            RETURN r
        

In [88]:
query = \
    """ 
    MATCH 
    (a:Instauser) - [:MEMBER_OF] - (:Community {name: '0'})
    RETURN a.name AS name
"""

results = graph.run(query).data()
instausers = [i['name'] for i in results]

assert len(list(communities.keys())) == len(instausers)

In [89]:
assert set(list(communities.keys())) == set(instausers)

In [206]:
G = nx.read_gpickle('/home/epfl/data/output.nx')

In [207]:
outdeg = G.degree()
to_remove = [n for n in outdeg if outdeg[n] == 1]

to_keep = [n for n in outdeg if outdeg[n] != 1]
sub = G.subgraph(to_keep)

In [208]:
len(sub.nodes())

G = sub

In [210]:
query = """
    CREATE (a:Community {name: 0})
    RETURN a
    """
    
graph.run(query)

for node in G.nodes():
    query = """
            MATCH (a:Instauser),(b:Community)
            WHERE a.name = %s AND b.name = 0
            CREATE (a)-[r:MEMBER_OF]->(b)
            RETURN r
        """ % (node)

    graph.run(query)

In [196]:
nodes = {}
edges = {}

query = """
    CREATE (a:Community {name: 0})
    RETURN a
    """
    
graph.run(query)
for node in G.nodes():
    query = """
    CREATE (a:Instauser {name: %s})
    RETURN a
    """ % str(node)
    
    graph.run(query)
    

    
for source, target in G.edges():
    query = """
            MATCH (a:Instauser),(b:Instauser)
            WHERE a.name = %s AND b.name = %s
            CREATE (a)-[r:LIKED]->(b)
            RETURN r
        """ % (source, target)

    graph.run(query)

In [178]:
nodes


Out[178]:
{36950375: (:Instauser {name: '36950375'}),
 227821023: (:Instauser {name: '227821023'}),
 321272: (:Instauser {name: '321272'}),
 7074412: (:Instauser {name: '7074412'}),
 1779894666: (:Instauser {name: '1779894666'}),
 524980639: (:Instauser {name: '524980639'}),
 772581894: (:Instauser {name: '772581894'}),
 5443599152: (:Instauser {name: '5443599152'}),
 1572241409: (:Instauser {name: '1572241409'}),
 323835957: (:Instauser {name: '323835957'}),
 357095537: (:Instauser {name: '357095537'}),
 5996359794: (:Instauser {name: '5996359794'}),
 2275500165: (:Instauser {name: '2275500165'}),
 333078712: (:Instauser {name: '333078712'}),
 5912606913: (:Instauser {name: '5912606913'}),
 305887429: (:Instauser {name: '305887429'}),
 209293513: (:Instauser {name: '209293513'}),
 1317699805: (:Instauser {name: '1317699805'}),
 1813956840: (:Instauser {name: '1813956840'}),
 3678617854: (:Instauser {name: '3678617854'}),
 1309886720: (:Instauser {name: '1309886720'}),
 457552142: (:Instauser {name: '457552142'}),
 2024919313: (:Instauser {name: '2024919313'}),
 3996821788: (:Instauser {name: '3996821788'}),
 1298422046: (:Instauser {name: '1298422046'}),
 1443031356: (:Instauser {name: '1443031356'}),
 570253636: (:Instauser {name: '570253636'}),
 4827717977: (:Instauser {name: '4827717977'}),
 5474885990: (:Instauser {name: '5474885990'}),
 378827113: (:Instauser {name: '378827113'}),
 6193359217: (:Instauser {name: '6193359217'}),
 5992417673: (:Instauser {name: '5992417673'}),
 1629378964: (:Instauser {name: '1629378964'}),
 4734722452: (:Instauser {name: '4734722452'}),
 25489829: (:Instauser {name: '25489829'}),
 41656754: (:Instauser {name: '41656754'}),
 2004939200: (:Instauser {name: '2004939200'}),
 1467533764: (:Instauser {name: '1467533764'}),
 248793549: (:Instauser {name: '248793549'}),
 3612895734: (:Instauser {name: '3612895734'}),
 194660866: (:Instauser {name: '194660866'}),
 618695195: (:Instauser {name: '618695195'}),
 2287409729: (:Instauser {name: '2287409729'}),
 50690646: (:Instauser {name: '50690646'}),
 565590641: (:Instauser {name: '565590641'}),
 3640879767: (:Instauser {name: '3640879767'}),
 3465169573: (:Instauser {name: '3465169573'}),
 1647520425: (:Instauser {name: '1647520425'}),
 2266645206: (:Instauser {name: '2266645206'}),
 33878767: (:Instauser {name: '33878767'}),
 1554369274: (:Instauser {name: '1554369274'}),
 48382762: (:Instauser {name: '48382762'}),
 217144106: (:Instauser {name: '217144106'}),
 2273551151: (:Instauser {name: '2273551151'}),
 401513287: (:Instauser {name: '401513287'}),
 4479474514: (:Instauser {name: '4479474514'}),
 2888550: (:Instauser {name: '2888550'}),
 3625227121: (:Instauser {name: '3625227121'}),
 4231254900: (:Instauser {name: '4231254900'}),
 2651001: (:Instauser {name: '2651001'}),
 1452870538: (:Instauser {name: '1452870538'}),
 5433007006: (:Instauser {name: '5433007006'}),
 15612836: (:Instauser {name: '15612836'}),
 1407909: (:Instauser {name: '1407909'}),
 2427780010: (:Instauser {name: '2427780010'}),
 1519725490: (:Instauser {name: '1519725490'}),
 3550166000: (:Instauser {name: '3550166000'}),
 1475400696: (:Instauser {name: '1475400696'}),
 4216290303: (:Instauser {name: '4216290303'}),
 1165208595: (:Instauser {name: '1165208595'}),
 362869799: (:Instauser {name: '362869799'}),
 6246054987: (:Instauser {name: '6246054987'}),
 3468512340: (:Instauser {name: '3468512340'}),
 291095641: (:Instauser {name: '291095641'}),
 5866728559: (:Instauser {name: '5866728559'}),
 20110451: (:Instauser {name: '20110451'}),
 4058471558: (:Instauser {name: '4058471558'}),
 2096366738: (:Instauser {name: '2096366738'}),
 3505763512: (:Instauser {name: '3505763512'}),
 49429730: (:Instauser {name: '49429730'}),
 5981342956: (:Instauser {name: '5981342956'}),
 314146034: (:Instauser {name: '314146034'}),
 5443116299: (:Instauser {name: '5443116299'}),
 275367216: (:Instauser {name: '275367216'}),
 3435001136: (:Instauser {name: '3435001136'}),
 2150317374: (:Instauser {name: '2150317374'}),
 3270229338: (:Instauser {name: '3270229338'}),
 32372064: (:Instauser {name: '32372064'}),
 347725192: (:Instauser {name: '347725192'}),
 2000332172: (:Instauser {name: '2000332172'}),
 21716380: (:Instauser {name: '21716380'}),
 1722600866: (:Instauser {name: '1722600866'}),
 179439030: (:Instauser {name: '179439030'}),
 2221913527: (:Instauser {name: '2221913527'}),
 5451343305: (:Instauser {name: '5451343305'}),
 3645189582: (:Instauser {name: '3645189582'}),
 3292110310: (:Instauser {name: '3292110310'}),
 3130858998: (:Instauser {name: '3130858998'}),
 1548994050: (:Instauser {name: '1548994050'}),
 492936716: (:Instauser {name: '492936716'}),
 6311874063: (:Instauser {name: '6311874063'}),
 5924703794: (:Instauser {name: '5924703794'}),
 3171360335: (:Instauser {name: '3171360335'}),
 50259536: (:Instauser {name: '50259536'}),
 1432925786: (:Instauser {name: '1432925786'}),
 1379915374: (:Instauser {name: '1379915374'}),
 1004639879: (:Instauser {name: '1004639879'}),
 4409689736: (:Instauser {name: '4409689736'}),
 5818939025: (:Instauser {name: '5818939025'}),
 6018784934: (:Instauser {name: '6018784934'}),
 5982404298: (:Instauser {name: '5982404298'}),
 267951829: (:Instauser {name: '267951829'}),
 3289913076: (:Instauser {name: '3289913076'}),
 5377126190: (:Instauser {name: '5377126190'}),
 1558406959: (:Instauser {name: '1558406959'}),
 5747402590: (:Instauser {name: '5747402590'}),
 581640064: (:Instauser {name: '581640064'}),
 364429185: (:Instauser {name: '364429185'}),
 3432359811: (:Instauser {name: '3432359811'}),
 240582534: (:Instauser {name: '240582534'}),
 6295433: (:Instauser {name: '6295433'}),
 1326989214: (:Instauser {name: '1326989214'}),
 187303840: (:Instauser {name: '187303840'}),
 229930916: (:Instauser {name: '229930916'}),
 3578871749: (:Instauser {name: '3578871749'}),
 2974492622: (:Instauser {name: '2974492622'}),
 2911229918: (:Instauser {name: '2911229918'}),
 4418674667: (:Instauser {name: '4418674667'}),
 1348106225: (:Instauser {name: '1348106225'}),
 1371924472: (:Instauser {name: '1371924472'}),
 3582327819: (:Instauser {name: '3582327819'}),
 206411276: (:Instauser {name: '206411276'}),
 31564302: (:Instauser {name: '31564302'}),
 232078352: (:Instauser {name: '232078352'}),
 3086466577: (:Instauser {name: '3086466577'}),
 2095206417: (:Instauser {name: '2095206417'}),
 1277021720: (:Instauser {name: '1277021720'}),
 4622458906: (:Instauser {name: '4622458906'}),
 6207049243: (:Instauser {name: '6207049243'}),
 5894905886: (:Instauser {name: '5894905886'}),
 48834083: (:Instauser {name: '48834083'}),
 2074352678: (:Instauser {name: '2074352678'}),
 24233512: (:Instauser {name: '24233512'}),
 41230892: (:Instauser {name: '41230892'}),
 2009449004: (:Instauser {name: '2009449004'}),
 3231818803: (:Instauser {name: '3231818803'}),
 5774472248: (:Instauser {name: '5774472248'}),
 509896762: (:Instauser {name: '509896762'}),
 1022158398: (:Instauser {name: '1022158398'}),
 417925184: (:Instauser {name: '417925184'}),
 195664963: (:Instauser {name: '195664963'}),
 2963609155: (:Instauser {name: '2963609155'}),
 184118855: (:Instauser {name: '184118855'}),
 227031106: (:Instauser {name: '227031106'}),
 2160086594: (:Instauser {name: '2160086594'}),
 24745034: (:Instauser {name: '24745034'}),
 4196608075: (:Instauser {name: '4196608075'}),
 242294355: (:Instauser {name: '242294355'}),
 26028630: (:Instauser {name: '26028630'}),
 1989568090: (:Instauser {name: '1989568090'}),
 1118789217: (:Instauser {name: '1118789217'}),
 3557034593: (:Instauser {name: '3557034593'}),
 183282792: (:Instauser {name: '183282792'}),
 3670518889: (:Instauser {name: '3670518889'}),
 6677190767: (:Instauser {name: '6677190767'}),
 4513980532: (:Instauser {name: '4513980532'}),
 2980340853: (:Instauser {name: '2980340853'}),
 6241946234: (:Instauser {name: '6241946234'}),
 241197690: (:Instauser {name: '241197690'}),
 3623159932: (:Instauser {name: '3623159932'}),
 1578128001: (:Instauser {name: '1578128001'}),
 412113542: (:Instauser {name: '412113542'}),
 5524019851: (:Instauser {name: '5524019851'}),
 5686902925: (:Instauser {name: '5686902925'}),
 2141130379: (:Instauser {name: '2141130379'}),
 410511504: (:Instauser {name: '410511504'}),
 4178779279: (:Instauser {name: '4178779279'}),
 38393493: (:Instauser {name: '38393493'}),
 3181585048: (:Instauser {name: '3181585048'}),
 6113375385: (:Instauser {name: '6113375385'}),
 4560601753: (:Instauser {name: '4560601753'}),
 3056102048: (:Instauser {name: '3056102048'}),
 1803360933: (:Instauser {name: '1803360933'}),
 1615465142: (:Instauser {name: '1615465142'}),
 50815158: (:Instauser {name: '50815158'}),
 1619001532: (:Instauser {name: '1619001532'}),
 46184128: (:Instauser {name: '46184128'}),
 1859268: (:Instauser {name: '1859268'}),
 581918911: (:Instauser {name: '581918911'}),
 3108887230: (:Instauser {name: '3108887230'}),
 6084518600: (:Instauser {name: '6084518600'}),
 19651788: (:Instauser {name: '19651788'}),
 5643581142: (:Instauser {name: '5643581142'}),
 3110102232: (:Instauser {name: '3110102232'}),
 3591254745: (:Instauser {name: '3591254745'}),
 3086222552: (:Instauser {name: '3086222552'}),
 216488156: (:Instauser {name: '216488156'}),
 2102309598: (:Instauser {name: '2102309598'}),
 3582701278: (:Instauser {name: '3582701278'}),
 1506213605: (:Instauser {name: '1506213605'}),
 235880182: (:Instauser {name: '235880182'}),
 248205048: (:Instauser {name: '248205048'}),
 5727627524: (:Instauser {name: '5727627524'}),
 644650764: (:Instauser {name: '644650764'}),
 30165261: (:Instauser {name: '30165261'}),
 3062770957: (:Instauser {name: '3062770957'}),
 1462475023: (:Instauser {name: '1462475023'}),
 52649758: (:Instauser {name: '52649758'}),
 4487870239: (:Instauser {name: '4487870239'}),
 1364455198: (:Instauser {name: '1364455198'}),
 179069222: (:Instauser {name: '179069222'}),
 5804184363: (:Instauser {name: '5804184363'}),
 4367665455: (:Instauser {name: '4367665455'}),
 272297264: (:Instauser {name: '272297264'}),
 4845087537: (:Instauser {name: '4845087537'}),
 1217474868: (:Instauser {name: '1217474868'}),
 5652755261: (:Instauser {name: '5652755261'}),
 3700876098: (:Instauser {name: '3700876098'}),
 6012605762: (:Instauser {name: '6012605762'}),
 213492043: (:Instauser {name: '213492043'}),
 11977553: (:Instauser {name: '11977553'}),
 2729039700: (:Instauser {name: '2729039700'}),
 6079837031: (:Instauser {name: '6079837031'}),
 2162849638: (:Instauser {name: '2162849638'}),
 1932023657: (:Instauser {name: '1932023657'}),
 6313763690: (:Instauser {name: '6313763690'}),
 184039281: (:Instauser {name: '184039281'}),
 4209302904: (:Instauser {name: '4209302904'}),
 1621010809: (:Instauser {name: '1621010809'}),
 964284795: (:Instauser {name: '964284795'}),
 2287752060: (:Instauser {name: '2287752060'}),
 5612854653: (:Instauser {name: '5612854653'}),
 3529896317: (:Instauser {name: '3529896317'}),
 3582565249: (:Instauser {name: '3582565249'}),
 2021820804: (:Instauser {name: '2021820804'}),
 7977862: (:Instauser {name: '7977862'}),
 200606599: (:Instauser {name: '200606599'}),
 2239976328: (:Instauser {name: '2239976328'}),
 3946216326: (:Instauser {name: '3946216326'}),
 285525397: (:Instauser {name: '285525397'}),
 3868266910: (:Instauser {name: '3868266910'}),
 2774432: (:Instauser {name: '2774432'}),
 265553313: (:Instauser {name: '265553313'}),
 369808808: (:Instauser {name: '369808808'}),
 1966109610: (:Instauser {name: '1966109610'}),
 218549676: (:Instauser {name: '218549676'}),
 911264179: (:Instauser {name: '911264179'}),
 4293860788: (:Instauser {name: '4293860788'}),
 1478809017: (:Instauser {name: '1478809017'}),
 1730584514: (:Instauser {name: '1730584514'}),
 8126408: (:Instauser {name: '8126408'}),
 55757264: (:Instauser {name: '55757264'}),
 143910352: (:Instauser {name: '143910352'}),
 235087316: (:Instauser {name: '235087316'}),
 21025238: (:Instauser {name: '21025238'}),
 881107413: (:Instauser {name: '881107413'}),
 2257547737: (:Instauser {name: '2257547737'}),
 498965468: (:Instauser {name: '498965468'}),
 3258831841: (:Instauser {name: '3258831841'}),
 3082257896: (:Instauser {name: '3082257896'}),
 2284201449: (:Instauser {name: '2284201449'}),
 2111218668: (:Instauser {name: '2111218668'}),
 4018119664: (:Instauser {name: '4018119664'}),
 190659063: (:Instauser {name: '190659063'}),
 188875770: (:Instauser {name: '188875770'}),
 1692891138: (:Instauser {name: '1692891138'}),
 21560877: (:Instauser {name: '21560877'}),
 261873203: (:Instauser {name: '261873203'}),
 3541801012: (:Instauser {name: '3541801012'}),
 16181825: (:Instauser {name: '16181825'}),
 2015672905: (:Instauser {name: '2015672905'}),
 2082713181: (:Instauser {name: '2082713181'}),
 10876526: (:Instauser {name: '10876526'}),
 4080712814: (:Instauser {name: '4080712814'}),
 227917939: (:Instauser {name: '227917939'}),
 1599916680: (:Instauser {name: '1599916680'}),
 8713355: (:Instauser {name: '8713355'}),
 196809366: (:Instauser {name: '196809366'}),
 145362583: (:Instauser {name: '145362583'}),
 184195742: (:Instauser {name: '184195742'}),
 3676635815: (:Instauser {name: '3676635815'}),
 328165572: (:Instauser {name: '328165572'}),
 4843330757: (:Instauser {name: '4843330757'}),
 5718432970: (:Instauser {name: '5718432970'}),
 3083022031: (:Instauser {name: '3083022031'}),
 1377122008: (:Instauser {name: '1377122008'}),
 5340818140: (:Instauser {name: '5340818140'}),
 5328222949: (:Instauser {name: '5328222949'}),
 5665820907: (:Instauser {name: '5665820907'}),
 2179036407: (:Instauser {name: '2179036407'}),
 5638042875: (:Instauser {name: '5638042875'}),
 213765378: (:Instauser {name: '213765378'}),
 177328419: (:Instauser {name: '177328419'}),
 20344639: (:Instauser {name: '20344639'}),
 6281392968: (:Instauser {name: '6281392968'}),
 8748369: (:Instauser {name: '8748369'}),
 1459842046: (:Instauser {name: '1459842046'}),
 224414050: (:Instauser {name: '224414050'}),
 1466519394: (:Instauser {name: '1466519394'}),
 220310910: (:Instauser {name: '220310910'}),
 3235809665: (:Instauser {name: '3235809665'}),
 2039080845: (:Instauser {name: '2039080845'}),
 470999444: (:Instauser {name: '470999444'}),
 354895257: (:Instauser {name: '354895257'}),
 302326696: (:Instauser {name: '302326696'}),
 2183156662: (:Instauser {name: '2183156662'}),
 297585598: (:Instauser {name: '297585598'}),
 200298434: (:Instauser {name: '200298434'}),
 4005131719: (:Instauser {name: '4005131719'}),
 4270560: (:Instauser {name: '4270560'}),
 3987599855: (:Instauser {name: '3987599855'}),
 4942719996: (:Instauser {name: '4942719996'}),
 1781151756: (:Instauser {name: '1781151756'}),
 4420996622: (:Instauser {name: '4420996622'}),
 261210128: (:Instauser {name: '261210128'}),
 5434660883: (:Instauser {name: '5434660883'}),
 49266712: (:Instauser {name: '49266712'}),
 349167135: (:Instauser {name: '349167135'}),
 1397515812: (:Instauser {name: '1397515812'}),
 6471603764: (:Instauser {name: '6471603764'}),
 5938507845: (:Instauser {name: '5938507845'}),
 2974620240: (:Instauser {name: '2974620240'}),
 5721040471: (:Instauser {name: '5721040471'}),
 3537740405: (:Instauser {name: '3537740405'}),
 2308179592: (:Instauser {name: '2308179592'}),
 1516233360: (:Instauser {name: '1516233360'}),
 34165907: (:Instauser {name: '34165907'}),
 4145795741: (:Instauser {name: '4145795741'}),
 505627807: (:Instauser {name: '505627807'}),
 183755937: (:Instauser {name: '183755937'}),
 2898632363: (:Instauser {name: '2898632363'}),
 4871701187: (:Instauser {name: '4871701187'}),
 6076957388: (:Instauser {name: '6076957388'}),
 235508429: (:Instauser {name: '235508429'}),
 2234513108: (:Instauser {name: '2234513108'}),
 15162367: (:Instauser {name: '15162367'}),
 428051682: (:Instauser {name: '428051682'}),
 2460466405: (:Instauser {name: '2460466405'}),
 6413033: (:Instauser {name: '6413033'}),
 1405370607: (:Instauser {name: '1405370607'}),
 1668575984: (:Instauser {name: '1668575984'}),
 3593366767: (:Instauser {name: '3593366767'}),
 240719612: (:Instauser {name: '240719612'}),
 3510385410: (:Instauser {name: '3510385410'}),
 816902: (:Instauser {name: '816902'}),
 6516914445: (:Instauser {name: '6516914445'}),
 5472859922: (:Instauser {name: '5472859922'}),
 4225017108: (:Instauser {name: '4225017108'}),
 4522669842: (:Instauser {name: '4522669842'}),
 1936430367: (:Instauser {name: '1936430367'}),
 3544131874: (:Instauser {name: '3544131874'}),
 31207209: (:Instauser {name: '31207209'}),
 5391746349: (:Instauser {name: '5391746349'}),
 739116338: (:Instauser {name: '739116338'}),
 453796149: (:Instauser {name: '453796149'}),
 1316150: (:Instauser {name: '1316150'}),
 1437369159: (:Instauser {name: '1437369159'}),
 3056997004: (:Instauser {name: '3056997004'}),
 33554269: (:Instauser {name: '33554269'}),
 510250353: (:Instauser {name: '510250353'}),
 585509238: (:Instauser {name: '585509238'}),
 4852349301: (:Instauser {name: '4852349301'}),
 1324407164: (:Instauser {name: '1324407164'}),
 4451714: (:Instauser {name: '4451714'}),
 43672476: (:Instauser {name: '43672476'}),
 990367651: (:Instauser {name: '990367651'}),
 4968964003: (:Instauser {name: '4968964003'}),
 1985720740: (:Instauser {name: '1985720740'}),
 5850021803: (:Instauser {name: '5850021803'}),
 1539776429: (:Instauser {name: '1539776429'}),
 208564145: (:Instauser {name: '208564145'}),
 2106762677: (:Instauser {name: '2106762677'}),
 2250678: (:Instauser {name: '2250678'}),
 3618886071: (:Instauser {name: '3618886071'}),
 223532988: (:Instauser {name: '223532988'}),
 2323320765: (:Instauser {name: '2323320765'}),
 6207807432: (:Instauser {name: '6207807432'}),
 11796937: (:Instauser {name: '11796937'}),
 435870669: (:Instauser {name: '435870669'}),
 1130656208: (:Instauser {name: '1130656208'}),
 5560204796: (:Instauser {name: '5560204796'}),
 23089632: (:Instauser {name: '23089632'}),
 55966177: (:Instauser {name: '55966177'}),
 144727025: (:Instauser {name: '144727025'}),
 144190963: (:Instauser {name: '144190963'}),
 284052482: (:Instauser {name: '284052482'}),
 6369554451: (:Instauser {name: '6369554451'}),
 2256344112: (:Instauser {name: '2256344112'}),
 4398693945: (:Instauser {name: '4398693945'}),
 2318636618: (:Instauser {name: '2318636618'}),
 1343619147: (:Instauser {name: '1343619147'}),
 5414973539: (:Instauser {name: '5414973539'}),
 559788683: (:Instauser {name: '559788683'}),
 1780561118: (:Instauser {name: '1780561118'}),
 4847492321: (:Instauser {name: '4847492321'}),
 1433895152: (:Instauser {name: '1433895152'}),
 20451569: (:Instauser {name: '20451569'}),
 1507089143: (:Instauser {name: '1507089143'}),
 32085789: (:Instauser {name: '32085789'}),
 43221808: (:Instauser {name: '43221808'}),
 3643424598: (:Instauser {name: '3643424598'}),
 5384863063: (:Instauser {name: '5384863063'}),
 1005973352: (:Instauser {name: '1005973352'}),
 17146323: (:Instauser {name: '17146323'}),
 1126834133: (:Instauser {name: '1126834133'}),
 1515661801: (:Instauser {name: '1515661801'}),
 27504142: (:Instauser {name: '27504142'}),
 543139854: (:Instauser {name: '543139854'}),
 1527993368: (:Instauser {name: '1527993368'}),
 1909968925: (:Instauser {name: '1909968925'}),
 1618624040: (:Instauser {name: '1618624040'}),
 247629866: (:Instauser {name: '247629866'}),
 278588457: (:Instauser {name: '278588457'}),
 190221876: (:Instauser {name: '190221876'}),
 6206514: (:Instauser {name: '6206514'}),
 4021536827: (:Instauser {name: '4021536827'}),
 4248932934: (:Instauser {name: '4248932934'}),
 2071909960: (:Instauser {name: '2071909960'}),
 247389269: (:Instauser {name: '247389269'}),
 503117923: (:Instauser {name: '503117923'}),
 3575601771: (:Instauser {name: '3575601771'}),
 8334963: (:Instauser {name: '8334963'}),
 3087469176: (:Instauser {name: '3087469176'}),
 39002233: (:Instauser {name: '39002233'}),
 5770181243: (:Instauser {name: '5770181243'}),
 5437706365: (:Instauser {name: '5437706365'}),
 581310611: (:Instauser {name: '581310611'}),
 48713879: (:Instauser {name: '48713879'}),
 758955: (:Instauser {name: '758955'}),
 1902515910: (:Instauser {name: '1902515910'}),
 3666635: (:Instauser {name: '3666635'}),
 3414653645: (:Instauser {name: '3414653645'}),
 3462640851: (:Instauser {name: '3462640851'}),
 6238296291: (:Instauser {name: '6238296291'}),
 539100391: (:Instauser {name: '539100391'}),
 1829452009: (:Instauser {name: '1829452009'}),
 2947223795: (:Instauser {name: '2947223795'}),
 1153684724: (:Instauser {name: '1153684724'}),
 29852926: (:Instauser {name: '29852926'}),
 26301704: (:Instauser {name: '26301704'}),
 28579595: (:Instauser {name: '28579595'}),
 5273694483: (:Instauser {name: '5273694483'}),
 574126361: (:Instauser {name: '574126361'}),
 39972636: (:Instauser {name: '39972636'}),
 51974440: (:Instauser {name: '51974440'}),
 5026132779: (:Instauser {name: '5026132779'}),
 5721301829: (:Instauser {name: '5721301829'}),
 2316007247: (:Instauser {name: '2316007247'}),
 3571755857: (:Instauser {name: '3571755857'}),
 2294696801: (:Instauser {name: '2294696801'}),
 243571559: (:Instauser {name: '243571559'}),
 276265844: (:Instauser {name: '276265844'}),
 44938629: (:Instauser {name: '44938629'}),
 1418631070: (:Instauser {name: '1418631070'}),
 15062947: (:Instauser {name: '15062947'}),
 207532976: (:Instauser {name: '207532976'}),
 278704054: (:Instauser {name: '278704054'}),
 628791744: (:Instauser {name: '628791744'}),
 42295747: (:Instauser {name: '42295747'}),
 28263369: (:Instauser {name: '28263369'}),
 197679593: (:Instauser {name: '197679593'}),
 1310506495: (:Instauser {name: '1310506495'}),
 2931905017: (:Instauser {name: '2931905017'}),
 6307154453: (:Instauser {name: '6307154453'}),
 6313043123: (:Instauser {name: '6313043123'}),
 5789087801: (:Instauser {name: '5789087801'}),
 189798845: (:Instauser {name: '189798845'}),
 2671348581: (:Instauser {name: '2671348581'}),
 4176085617: (:Instauser {name: '4176085617'}),
 2163345018: (:Instauser {name: '2163345018'}),
 219261075: (:Instauser {name: '219261075'}),
 3994566176: (:Instauser {name: '3994566176'}),
 5642111904: (:Instauser {name: '5642111904'}),
 1700715302: (:Instauser {name: '1700715302'}),
 1767685557: (:Instauser {name: '1767685557'}),
 6420773315: (:Instauser {name: '6420773315'}),
 233164138: (:Instauser {name: '233164138'}),
 444480248: (:Instauser {name: '444480248'}),
 13105187: (:Instauser {name: '13105187'}),
 1548276390: (:Instauser {name: '1548276390'}),
 2269099666: (:Instauser {name: '2269099666'}),
 4147090771: (:Instauser {name: '4147090771'}),
 1700247441: (:Instauser {name: '1700247441'}),
 6049088403: (:Instauser {name: '6049088403'}),
 1088445906: (:Instauser {name: '1088445906'}),
 41622997: (:Instauser {name: '41622997'}),
 6383046643: (:Instauser {name: '6383046643'}),
 4345837614: (:Instauser {name: '4345837614'}),
 509130908: (:Instauser {name: '509130908'}),
 193362288: (:Instauser {name: '193362288'}),
 261999056: (:Instauser {name: '261999056'}),
 1675762182: (:Instauser {name: '1675762182'}),
 652665443: (:Instauser {name: '652665443'}),
 179045134: (:Instauser {name: '179045134'}),
 291904355: (:Instauser {name: '291904355'}),
 337836964: (:Instauser {name: '337836964'}),
 6250396600: (:Instauser {name: '6250396600'}),
 223634457: (:Instauser {name: '223634457'}),
 5347779751: (:Instauser {name: '5347779751'}),
 299097650: (:Instauser {name: '299097650'}),
 5723332229: (:Instauser {name: '5723332229'}),
 4086087305: (:Instauser {name: '4086087305'}),
 536577708: (:Instauser {name: '536577708'}),
 1480275833: (:Instauser {name: '1480275833'}),
 1107507240: (:Instauser {name: '1107507240'}),
 180564533: (:Instauser {name: '180564533'}),
 25155666: (:Instauser {name: '25155666'}),
 6008013928: (:Instauser {name: '6008013928'}),
 5554387584: (:Instauser {name: '5554387584'}),
 1108887694: (:Instauser {name: '1108887694'}),
 3928990352: (:Instauser {name: '3928990352'}),
 3629185219: (:Instauser {name: '3629185219'}),
 6483907329: (:Instauser {name: '6483907329'}),
 4526265192: (:Instauser {name: '4526265192'}),
 3969219459: (:Instauser {name: '3969219459'}),
 1557936: (:Instauser {name: '1557936'}),
 3688286183: (:Instauser {name: '3688286183'}),
 228629230: (:Instauser {name: '228629230'}),
 502742067: (:Instauser {name: '502742067'}),
 35391640: (:Instauser {name: '35391640'}),
 4200976693: (:Instauser {name: '4200976693'}),
 304863235: (:Instauser {name: '304863235'}),
 1504114182: (:Instauser {name: '1504114182'}),
 27680776: (:Instauser {name: '27680776'}),
 225486855: (:Instauser {name: '225486855'}),
 625254405: (:Instauser {name: '625254405'}),
 1795314699: (:Instauser {name: '1795314699'}),
 244466180: (:Instauser {name: '244466180'}),
 1646944783: (:Instauser {name: '1646944783'}),
 2160774160: (:Instauser {name: '2160774160'}),
 208947729: (:Instauser {name: '208947729'}),
 5774613521: (:Instauser {name: '5774613521'}),
 192629272: (:Instauser {name: '192629272'}),
 17998873: (:Instauser {name: '17998873'}),
 312986651: (:Instauser {name: '312986651'}),
 183327260: (:Instauser {name: '183327260'}),
 214939168: (:Instauser {name: '214939168'}),
 225394209: (:Instauser {name: '225394209'}),
 6349204510: (:Instauser {name: '6349204510'}),
 289533989: (:Instauser {name: '289533989'}),
 216276523: (:Instauser {name: '216276523'}),
 201636909: (:Instauser {name: '201636909'}),
 345714223: (:Instauser {name: '345714223'}),
 44762674: (:Instauser {name: '44762674'}),
 1275825203: (:Instauser {name: '1275825203'}),
 233006644: (:Instauser {name: '233006644'}),
 2159717428: (:Instauser {name: '2159717428'}),
 1273815094: (:Instauser {name: '1273815094'}),
 1445689400: (:Instauser {name: '1445689400'}),
 553909309: (:Instauser {name: '553909309'}),
 33467972: (:Instauser {name: '33467972'}),
 1706678344: (:Instauser {name: '1706678344'}),
 35301449: (:Instauser {name: '35301449'}),
 261211211: (:Instauser {name: '261211211'}),
 10996812: (:Instauser {name: '10996812'}),
 10608211: (:Instauser {name: '10608211'}),
 176412243: (:Instauser {name: '176412243'}),
 247381590: (:Instauser {name: '247381590'}),
 194841177: (:Instauser {name: '194841177'}),
 49790041: (:Instauser {name: '49790041'}),
 2319176281: (:Instauser {name: '2319176281'}),
 1133629024: (:Instauser {name: '1133629024'}),
 53854304: (:Instauser {name: '53854304'}),
 1791180388: (:Instauser {name: '1791180388'}),
 691113979: (:Instauser {name: '691113979'}),
 198953576: (:Instauser {name: '198953576'}),
 26642027: (:Instauser {name: '26642027'}),
 258898539: (:Instauser {name: '258898539'}),
 197705325: (:Instauser {name: '197705325'}),
 184920685: (:Instauser {name: '184920685'}),
 3633081453: (:Instauser {name: '3633081453'}),
 273320045: (:Instauser {name: '273320045'}),
 35002994: (:Instauser {name: '35002994'}),
 53712493: (:Instauser {name: '53712493'}),
 6038273652: (:Instauser {name: '6038273652'}),
 5463510643: (:Instauser {name: '5463510643'}),
 1764754549: (:Instauser {name: '1764754549'}),
 2081357942: (:Instauser {name: '2081357942'}),
 187428986: (:Instauser {name: '187428986'}),
 145347706: (:Instauser {name: '145347706'}),
 204521601: (:Instauser {name: '204521601'}),
 263254147: (:Instauser {name: '263254147'}),
 321981574: (:Instauser {name: '321981574'}),
 1516960903: (:Instauser {name: '1516960903'}),
 265222281: (:Instauser {name: '265222281'}),
 194677386: (:Instauser {name: '194677386'}),
 695699083: (:Instauser {name: '695699083'}),
 3530036370: (:Instauser {name: '3530036370'}),
 397014674: (:Instauser {name: '397014674'}),
 224641685: (:Instauser {name: '224641685'}),
 1329260695: (:Instauser {name: '1329260695'}),
 40819869: (:Instauser {name: '40819869'}),
 273624226: (:Instauser {name: '273624226'}),
 379355298: (:Instauser {name: '379355298'}),
 9344677: (:Instauser {name: '9344677'}),
 2066080425: (:Instauser {name: '2066080425'}),
 4294116523: (:Instauser {name: '4294116523'}),
 1454309549: (:Instauser {name: '1454309549'}),
 4518129839: (:Instauser {name: '4518129839'}),
 657851056: (:Instauser {name: '657851056'}),
 224727219: (:Instauser {name: '224727219'}),
 5348352689: (:Instauser {name: '5348352689'}),
 46171322: (:Instauser {name: '46171322'}),
 1507464381: (:Instauser {name: '1507464381'}),
 593329341: (:Instauser {name: '593329341'}),
 178922174: (:Instauser {name: '178922174'}),
 1290975936: (:Instauser {name: '1290975936'}),
 203429056: (:Instauser {name: '203429056'}),
 229826762: (:Instauser {name: '229826762'}),
 4371011275: (:Instauser {name: '4371011275'}),
 289159372: (:Instauser {name: '289159372'}),
 3123941580: (:Instauser {name: '3123941580'}),
 176952523: (:Instauser {name: '176952523'}),
 2209910475: (:Instauser {name: '2209910475'}),
 6395975889: (:Instauser {name: '6395975889'}),
 1131672780: (:Instauser {name: '1131672780'}),
 726667988: (:Instauser {name: '726667988'}),
 42251990: (:Instauser {name: '42251990'}),
 221160662: (:Instauser {name: '221160662'}),
 1943630552: (:Instauser {name: '1943630552'}),
 4011521756: (:Instauser {name: '4011521756'}),
 245275356: (:Instauser {name: '245275356'}),
 2020220639: (:Instauser {name: '2020220639'}),
 1785976033: (:Instauser {name: '1785976033'}),
 216732901: (:Instauser {name: '216732901'}),
 446175977: (:Instauser {name: '446175977'}),
 262289131: (:Instauser {name: '262289131'}),
 3714145514: (:Instauser {name: '3714145514'}),
 506188015: (:Instauser {name: '506188015'}),
 292127989: (:Instauser {name: '292127989'}),
 191734517: (:Instauser {name: '191734517'}),
 40656629: (:Instauser {name: '40656629'}),
 841360634: (:Instauser {name: '841360634'}),
 233099515: (:Instauser {name: '233099515'}),
 5535971580: (:Instauser {name: '5535971580'}),
 313200893: (:Instauser {name: '313200893'}),
 2318175485: (:Instauser {name: '2318175485'}),
 4155441409: (:Instauser {name: '4155441409'}),
 40238337: (:Instauser {name: '40238337'}),
 298750211: (:Instauser {name: '298750211'}),
 818023170: (:Instauser {name: '818023170'}),
 297627397: (:Instauser {name: '297627397'}),
 217884423: (:Instauser {name: '217884423'}),
 282321163: (:Instauser {name: '282321163'}),
 199371022: (:Instauser {name: '199371022'}),
 40589069: (:Instauser {name: '40589069'}),
 255777038: (:Instauser {name: '255777038'}),
 191690515: (:Instauser {name: '191690515'}),
 5135637: (:Instauser {name: '5135637'}),
 5804525336: (:Instauser {name: '5804525336'}),
 3239987997: (:Instauser {name: '3239987997'}),
 4097309: (:Instauser {name: '4097309'}),
 260458782: (:Instauser {name: '260458782'}),
 1125138727: (:Instauser {name: '1125138727'}),
 335399208: (:Instauser {name: '335399208'}),
 10212135: (:Instauser {name: '10212135'}),
 2031758127: (:Instauser {name: '2031758127'}),
 5745525045: (:Instauser {name: '5745525045'}),
 1386806: (:Instauser {name: '1386806'}),
 208401720: (:Instauser {name: '208401720'}),
 20676921: (:Instauser {name: '20676921'}),
 189409081: (:Instauser {name: '189409081'}),
 1430137659: (:Instauser {name: '1430137659'}),
 193553214: (:Instauser {name: '193553214'}),
 276266303: (:Instauser {name: '276266303'}),
 196777791: (:Instauser {name: '196777791'}),
 243188546: (:Instauser {name: '243188546'}),
 6703207747: (:Instauser {name: '6703207747'}),
 190332740: (:Instauser {name: '190332740'}),
 381781316: (:Instauser {name: '381781316'}),
 594167623: (:Instauser {name: '594167623'}),
 258801992: (:Instauser {name: '258801992'}),
 332129099: (:Instauser {name: '332129099'}),
 1306577230: (:Instauser {name: '1306577230'}),
 32566092: (:Instauser {name: '32566092'}),
 5527061840: (:Instauser {name: '5527061840'}),
 4125520: (:Instauser {name: '4125520'}),
 709015380: (:Instauser {name: '709015380'}),
 630984024: (:Instauser {name: '630984024'}),
 463543129: (:Instauser {name: '463543129'}),
 54352732: (:Instauser {name: '54352732'}),
 42200412: (:Instauser {name: '42200412'}),
 1761115487: (:Instauser {name: '1761115487'}),
 298846562: (:Instauser {name: '298846562'}),
 241055075: (:Instauser {name: '241055075'}),
 1211288932: (:Instauser {name: '1211288932'}),
 1328408933: (:Instauser {name: '1328408933'}),
 371943273: (:Instauser {name: '371943273'}),
 1684237161: (:Instauser {name: '1684237161'}),
 186142574: (:Instauser {name: '186142574'}),
 1615837553: (:Instauser {name: '1615837553'}),
 174792052: (:Instauser {name: '174792052'}),
 24319358: (:Instauser {name: '24319358'}),
 1652423552: (:Instauser {name: '1652423552'}),
 181320576: (:Instauser {name: '181320576'}),
 449726851: (:Instauser {name: '449726851'}),
 143553924: (:Instauser {name: '143553924'}),
 356403077: (:Instauser {name: '356403077'}),
 1326155651: (:Instauser {name: '1326155651'}),
 5530854796: (:Instauser {name: '5530854796'}),
 1460303247: (:Instauser {name: '1460303247'}),
 217903508: (:Instauser {name: '217903508'}),
 1435956629: (:Instauser {name: '1435956629'}),
 239797144: (:Instauser {name: '239797144'}),
 3995324314: (:Instauser {name: '3995324314'}),
 205725601: (:Instauser {name: '205725601'}),
 378664954: (:Instauser {name: '378664954'}),
 21902845: (:Instauser {name: '21902845'}),
 358040994: (:Instauser {name: '358040994'}),
 178694569: (:Instauser {name: '178694569'}),
 1544976812: (:Instauser {name: '1544976812'}),
 619211180: (:Instauser {name: '619211180'}),
 605356465: (:Instauser {name: '605356465'}),
 41990581: (:Instauser {name: '41990581'}),
 4050764727: (:Instauser {name: '4050764727'}),
 3902135746: (:Instauser {name: '3902135746'}),
 5830275015: (:Instauser {name: '5830275015'}),
 3236355017: (:Instauser {name: '3236355017'}),
 222707661: (:Instauser {name: '222707661'}),
 460658129: (:Instauser {name: '460658129'}),
 46495697: (:Instauser {name: '46495697'}),
 410680276: (:Instauser {name: '410680276'}),
 264458709: (:Instauser {name: '264458709'}),
 179698646: (:Instauser {name: '179698646'}),
 270923736: (:Instauser {name: '270923736'}),
 5746309082: (:Instauser {name: '5746309082'}),
 15604699: (:Instauser {name: '15604699'}),
 37529054: (:Instauser {name: '37529054'}),
 1437281246: (:Instauser {name: '1437281246'}),
 369550818: (:Instauser {name: '369550818'}),
 44637667: (:Instauser {name: '44637667'}),
 5870391779: (:Instauser {name: '5870391779'}),
 213218789: (:Instauser {name: '213218789'}),
 191024106: (:Instauser {name: '191024106'}),
 49754089: (:Instauser {name: '49754089'}),
 21724141: (:Instauser {name: '21724141'}),
 1736663022: (:Instauser {name: '1736663022'}),
 3882089453: (:Instauser {name: '3882089453'}),
 194753005: (:Instauser {name: '194753005'}),
 2264177654: (:Instauser {name: '2264177654'}),
 6202264057: (:Instauser {name: '6202264057'}),
 4169939967: (:Instauser {name: '4169939967'}),
 6180933646: (:Instauser {name: '6180933646'}),
 4875892247: (:Instauser {name: '4875892247'}),
 1922874404: (:Instauser {name: '1922874404'}),
 3966416428: (:Instauser {name: '3966416428'}),
 745667120: (:Instauser {name: '745667120'}),
 44439090: (:Instauser {name: '44439090'}),
 2100231246: (:Instauser {name: '2100231246'}),
 6507821135: (:Instauser {name: '6507821135'}),
 2161777235: (:Instauser {name: '2161777235'}),
 26800731: (:Instauser {name: '26800731'}),
 5681575013: (:Instauser {name: '5681575013'}),
 3004266097: (:Instauser {name: '3004266097'}),
 2074931323: (:Instauser {name: '2074931323'}),
 2202586749: (:Instauser {name: '2202586749'}),
 182849675: (:Instauser {name: '182849675'}),
 1710007952: (:Instauser {name: '1710007952'}),
 3148998290: (:Instauser {name: '3148998290'}),
 3980919956: (:Instauser {name: '3980919956'}),
 2262060185: (:Instauser {name: '2262060185'}),
 2911430824: (:Instauser {name: '2911430824'}),
 1490110122: (:Instauser {name: '1490110122'}),
 251588778: (:Instauser {name: '251588778'}),
 4212508857: (:Instauser {name: '4212508857'}),
 212940996: (:Instauser {name: '212940996'}),
 1993904842: (:Instauser {name: '1993904842'}),
 3039345894: (:Instauser {name: '3039345894'}),
 213752561: (:Instauser {name: '213752561'}),
 2035906291: (:Instauser {name: '2035906291'}),
 1073503991: (:Instauser {name: '1073503991'}),
 12422917: (:Instauser {name: '12422917'}),
 2043423495: (:Instauser {name: '2043423495'}),
 6535863048: (:Instauser {name: '6535863048'}),
 5492370697: (:Instauser {name: '5492370697'}),
 606406414: (:Instauser {name: '606406414'}),
 5990730510: (:Instauser {name: '5990730510'}),
 3128705304: (:Instauser {name: '3128705304'}),
 5709658913: (:Instauser {name: '5709658913'}),
 4636470567: (:Instauser {name: '4636470567'}),
 40324904: (:Instauser {name: '40324904'}),
 54524735: (:Instauser {name: '54524735'}),
 36496723: (:Instauser {name: '36496723'}),
 5910474072: (:Instauser {name: '5910474072'}),
 4679198554: (:Instauser {name: '4679198554'}),
 490871140: (:Instauser {name: '490871140'}),
 312060774: (:Instauser {name: '312060774'}),
 3468235138: (:Instauser {name: '3468235138'}),
 1837068680: (:Instauser {name: '1837068680'}),
 885467533: (:Instauser {name: '885467533'}),
 3637821838: (:Instauser {name: '3637821838'}),
 4177249171: (:Instauser {name: '4177249171'}),
 4325232533: (:Instauser {name: '4325232533'}),
 42152355: (:Instauser {name: '42152355'}),
 188901812: (:Instauser {name: '188901812'}),
 482236341: (:Instauser {name: '482236341'}),
 357543354: (:Instauser {name: '357543354'}),
 1488660938: (:Instauser {name: '1488660938'}),
 46720978: (:Instauser {name: '46720978'}),
 1364725717: (:Instauser {name: '1364725717'}),
 1587642859: (:Instauser {name: '1587642859'}),
 53756913: (:Instauser {name: '53756913'}),
 14400502: (:Instauser {name: '14400502'}),
 46191632: (:Instauser {name: '46191632'}),
 52388893: (:Instauser {name: '52388893'}),
 3102683683: (:Instauser {name: '3102683683'}),
 32491070: (:Instauser {name: '32491070'}),
 277227597: (:Instauser {name: '277227597'}),
 4090792529: (:Instauser {name: '4090792529'}),
 5879275619: (:Instauser {name: '5879275619'}),
 4727728743: (:Instauser {name: '4727728743'}),
 22592617: (:Instauser {name: '22592617'}),
 178943086: (:Instauser {name: '178943086'}),
 208180339: (:Instauser {name: '208180339'}),
 4192365683: (:Instauser {name: '4192365683'}),
 201180799: (:Instauser {name: '201180799'}),
 1024239760: (:Instauser {name: '1024239760'}),
 23823511: (:Instauser {name: '23823511'}),
 291314848: (:Instauser {name: '291314848'}),
 2569967265: (:Instauser {name: '2569967265'}),
 336220340: (:Instauser {name: '336220340'}),
 1441173687: (:Instauser {name: '1441173687'}),
 360582849: (:Instauser {name: '360582849'}),
 9337541: (:Instauser {name: '9337541'}),
 4147978439: (:Instauser {name: '4147978439'}),
 2015113440: (:Instauser {name: '2015113440'}),
 211730155: (:Instauser {name: '211730155'}),
 306311922: (:Instauser {name: '306311922'}),
 4927912190: (:Instauser {name: '4927912190'}),
 52739342: (:Instauser {name: '52739342'}),
 190435091: (:Instauser {name: '190435091'}),
 5514834711: (:Instauser {name: '5514834711'}),
 3034172188: (:Instauser {name: '3034172188'}),
 7856422: (:Instauser {name: '7856422'}),
 509328679: (:Instauser {name: '509328679'}),
 1991209284: (:Instauser {name: '1991209284'}),
 593620808: (:Instauser {name: '593620808'}),
 201399627: (:Instauser {name: '201399627'}),
 196716378: (:Instauser {name: '196716378'}),
 208370535: (:Instauser {name: '208370535'}),
 174550895: (:Instauser {name: '174550895'}),
 242471798: (:Instauser {name: '242471798'}),
 184433027: (:Instauser {name: '184433027'}),
 6119860099: (:Instauser {name: '6119860099'}),
 2964382601: (:Instauser {name: '2964382601'}),
 48346515: (:Instauser {name: '48346515'}),
 2205139350: (:Instauser {name: '2205139350'}),
 260074915: (:Instauser {name: '260074915'}),
 3995671972: (:Instauser {name: '3995671972'}),
 9344935: (:Instauser {name: '9344935'}),
 320721316: (:Instauser {name: '320721316'}),
 39721897: (:Instauser {name: '39721897'}),
 1218333123: (:Instauser {name: '1218333123'}),
 25499609: (:Instauser {name: '25499609'}),
 5430225885: (:Instauser {name: '5430225885'}),
 42732007: (:Instauser {name: '42732007'}),
 5101188080: (:Instauser {name: '5101188080'}),
 1146885623: (:Instauser {name: '1146885623'}),
 4059301889: (:Instauser {name: '4059301889'}),
 6326795788: (:Instauser {name: '6326795788'}),
 51644944: (:Instauser {name: '51644944'}),
 3038247955: (:Instauser {name: '3038247955'}),
 13153811: (:Instauser {name: '13153811'}),
 738635283: (:Instauser {name: '738635283'}),
 37660197: (:Instauser {name: '37660197'}),
 4145206829: (:Instauser {name: '4145206829'}),
 1128218680: (:Instauser {name: '1128218680'}),
 258112585: (:Instauser {name: '258112585'}),
 716115532: (:Instauser {name: '716115532'}),
 1224086608: (:Instauser {name: '1224086608'}),
 213433959: (:Instauser {name: '213433959'}),
 5449755760: (:Instauser {name: '5449755760'}),
 1522853493: (:Instauser {name: '1522853493'}),
 335192186: (:Instauser {name: '335192186'}),
 5356837506: (:Instauser {name: '5356837506'}),
 4017622658: (:Instauser {name: '4017622658'}),
 1649614479: (:Instauser {name: '1649614479'}),
 3540402324: (:Instauser {name: '3540402324'}),
 4229229729: (:Instauser {name: '4229229729'}),
 2257398439: (:Instauser {name: '2257398439'}),
 2948327080: (:Instauser {name: '2948327080'}),
 3667922602: (:Instauser {name: '3667922602'}),
 5326369967: (:Instauser {name: '5326369967'}),
 203175100: (:Instauser {name: '203175100'}),
 4374526660: (:Instauser {name: '4374526660'}),
 1700880585: (:Instauser {name: '1700880585'}),
 277841100: (:Instauser {name: '277841100'}),
 385755853: (:Instauser {name: '385755853'}),
 4158431955: (:Instauser {name: '4158431955'}),
 5887993571: (:Instauser {name: '5887993571'}),
 283720452: (:Instauser {name: '283720452'}),
 226404620: (:Instauser {name: '226404620'}),
 648831761: (:Instauser {name: '648831761'}),
 12008742: (:Instauser {name: '12008742'}),
 54506805: (:Instauser {name: '54506805'}),
 25320765: (:Instauser {name: '25320765'}),
 5367103810: (:Instauser {name: '5367103810'}),
 5735554375: (:Instauser {name: '5735554375'}),
 265901907: (:Instauser {name: '265901907'}),
 258301782: (:Instauser {name: '258301782'}),
 4567813462: (:Instauser {name: '4567813462'}),
 1073841001: (:Instauser {name: '1073841001'}),
 1612548469: (:Instauser {name: '1612548469'}),
 4231485813: (:Instauser {name: '4231485813'}),
 4098291614: (:Instauser {name: '4098291614'}),
 259032994: (:Instauser {name: '259032994'}),
 247097271: (:Instauser {name: '247097271'}),
 1790530998: (:Instauser {name: '1790530998'}),
 5666945980: (:Instauser {name: '5666945980'}),
 2781640: (:Instauser {name: '2781640'}),
 1528014803: (:Instauser {name: '1528014803'}),
 4474549214: (:Instauser {name: '4474549214'}),
 8736755: (:Instauser {name: '8736755'}),
 4507102205: (:Instauser {name: '4507102205'}),
 5678386696: (:Instauser {name: '5678386696'}),
 2067539530: (:Instauser {name: '2067539530'}),
 240518274: (:Instauser {name: '240518274'}),
 299255812: (:Instauser {name: '299255812'}),
 2031248267: (:Instauser {name: '2031248267'}),
 440342671: (:Instauser {name: '440342671'}),
 3197167772: (:Instauser {name: '3197167772'}),
 6337271963: (:Instauser {name: '6337271963'}),
 4519535266: (:Instauser {name: '4519535266'}),
 6570559524: (:Instauser {name: '6570559524'}),
 34261033: (:Instauser {name: '34261033'}),
 2440466474: (:Instauser {name: '2440466474'}),
 3190802607: (:Instauser {name: '3190802607'}),
 4139355825: (:Instauser {name: '4139355825'}),
 6427581617: (:Instauser {name: '6427581617'}),
 1735362685: (:Instauser {name: '1735362685'}),
 5516474307: (:Instauser {name: '5516474307'}),
 5870576705: (:Instauser {name: '5870576705'}),
 2941956041: (:Instauser {name: '2941956041'}),
 33864905: (:Instauser {name: '33864905'}),
 6215067090: (:Instauser {name: '6215067090'}),
 6204963166: (:Instauser {name: '6204963166'}),
 1444523747: (:Instauser {name: '1444523747'}),
 1256892649: (:Instauser {name: '1256892649'}),
 6060937213: (:Instauser {name: '6060937213'}),
 1541230: (:Instauser {name: '1541230'}),
 211623542: (:Instauser {name: '211623542'}),
 329289335: (:Instauser {name: '329289335'}),
 3034169722: (:Instauser {name: '3034169722'}),
 6378759681: (:Instauser {name: '6378759681'}),
 1017349: (:Instauser {name: '1017349'}),
 199335947: (:Instauser {name: '199335947'}),
 174644238: (:Instauser {name: '174644238'}),
 234871327: (:Instauser {name: '234871327'}),
 1978400808: (:Instauser {name: '1978400808'}),
 5705136681: (:Instauser {name: '5705136681'}),
 689067563: (:Instauser {name: '689067563'}),
 2165283383: (:Instauser {name: '2165283383'}),
 865215563: (:Instauser {name: '865215563'}),
 177327692: (:Instauser {name: '177327692'}),
 1618919003: (:Instauser {name: '1618919003'}),
 6564915832: (:Instauser {name: '6564915832'}),
 3539328142: (:Instauser {name: '3539328142'}),
 3652611217: (:Instauser {name: '3652611217'}),
 788010131: (:Instauser {name: '788010131'}),
 2174839963: (:Instauser {name: '2174839963'}),
 1578018986: (:Instauser {name: '1578018986'}),
 17929908: (:Instauser {name: '17929908'}),
 196449461: (:Instauser {name: '196449461'}),
 2928127190: (:Instauser {name: '2928127190'}),
 5840777436: (:Instauser {name: '5840777436'}),
 218922207: (:Instauser {name: '218922207'}),
 4284557044: (:Instauser {name: '4284557044'}),
 56012021: (:Instauser {name: '56012021'}),
 175021302: (:Instauser {name: '175021302'}),
 6018985211: (:Instauser {name: '6018985211'}),
 209817853: (:Instauser {name: '209817853'}),
 104843011: (:Instauser {name: '104843011'}),
 1836909835: (:Instauser {name: '1836909835'}),
 517633295: (:Instauser {name: '517633295'}),
 6208510229: (:Instauser {name: '6208510229'}),
 181683480: (:Instauser {name: '181683480'}),
 5877226786: (:Instauser {name: '5877226786'}),
 3046941987: (:Instauser {name: '3046941987'}),
 216300837: (:Instauser {name: '216300837'}),
 1445492014: (:Instauser {name: '1445492014'}),
 4212595010: (:Instauser {name: '4212595010'}),
 52905795: (:Instauser {name: '52905795'}),
 6211856197: (:Instauser {name: '6211856197'}),
 1819334484: (:Instauser {name: '1819334484'}),
 49518421: (:Instauser {name: '49518421'}),
 4035782997: (:Instauser {name: '4035782997'}),
 4937703773: (:Instauser {name: '4937703773'}),
 5931000672: (:Instauser {name: '5931000672'}),
 190948197: (:Instauser {name: '190948197'}),
 2208884069: (:Instauser {name: '2208884069'}),
 1187962217: (:Instauser {name: '1187962217'}),
 4814395769: (:Instauser {name: '4814395769'}),
 502765436: (:Instauser {name: '502765436'}),
 3088817025: (:Instauser {name: '3088817025'}),
 1229319554: (:Instauser {name: '1229319554'}),
 2262834052: (:Instauser {name: '2262834052'}),
 1444937610: (:Instauser {name: '1444937610'}),
 16508822: (:Instauser {name: '16508822'}),
 2285050274: (:Instauser {name: '2285050274'}),
 2125903781: (:Instauser {name: '2125903781'}),
 ...}

In [ ]:
data[0]

In [171]:
for l in data[:10]:
    print(l['name'])


537569
247447041
221684260
213951333
316236037
222306121
256829035
243203979
995045100
1032051758

In [199]:
import sys
sys.path.append('/home/epfl/ftp/insta-network/src')

from GraphDatabase import Database
db = Database()
graph = db.get_community(0)

In [200]:
graph.nodes()


Out[200]:
[]

In [ ]:
db.get_community(root_community)